■ iMIS integrates with the Microsoft SQL Server Reporting Service (SSRS)
■ iMIS also harnesses it to bring dynamic reporting capability to iMIS queries.
■ IQA reporting makes it possible to turn any query into an SSRS report:
□ Filtered and auto-formatted
□ Customized with sub-totals and layout settings
□ Easily saved back into the Document System
□ Easily saved to your workstation as an .RDL
□ Free report customization in Business Intelligence Studio
Report from every query
■ Every working query in iMIS can render a report in one click, without any modification
■ Create reports on the fly without having to learn a report designer
■ Reports inherit whatever filters the query contains
■ Changes to the query show up in IQA reports immediately
■ Built-in report navigation: start, end, next/previous page, jump to page
Auto-formatting
■ Query result columns become report columns
■ Formatting adjusts to fit the number of columns
■ Change column order just by reordering them in the query
Simple saving
■ No garbage: if you just create, view, and close a report, no files save or accumulate
■ You save your query changes separately from the report
■ Save to iMIS creates the report and template pair wherever you choose in the Document System
■ Saved reports can be exposed and shared throughout iMIS as any other report
■ Save to Workstation creates the report template (.RDL) on your file system, for offline editing
■ Exports report data to Excel (XLS) format
■ Exports formatted report to Adobe PDF
Subtotaling
■ On the Display tab of queries, columns can be subtotaled and totaled
■ Sort order controls order of subtotaling
■ Use Totals Only to create a summary view, of subtotals without data lines
Customizable layout
■ SystemConfig table holds SSRS parameters that set layout and formatting of all IQA reports
■ Control page size (such as A4 versus Letter) and lay out headers and footers
■ Control fonts, background and foreground colors, shading and separator lines
■ Set report language and unit of measure